Stored Procedures [dbo].[BAEOrderAnswerUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@OrderNumberfloat8
@OldOrderNumberfloat8
@QuestionIDint4
@OldQuestionIDint4
@Answervarchar(512)512
SQL Script
create procedure [dbo].[BAEOrderAnswerUpdate] @OrderNumber as
float,
    @OldOrderNumber AS float,
    @QuestionID AS int,
    @OldQuestionID AS int,
    @Answer AS varchar(512)
AS
    UPDATE OrderAnswer
    SET
    OrderNumber =     @OrderNumber,
    QuestionID =     @QuestionID,
    Answer =         @Answer        
            
    WHERE OrderNumber = @OldOrderNumber AND
    QuestionID = @OldQuestionID;

GO
Uses